I am trying to get my SQL7 server to set the db option "concat null yields null".
The command passes without error and I even confirm the value under sysdatabases table.
The only way I can get Null to concat is to set the compatibility level back to 6.5, but this is not what I want to do.

Have anyone been successful in setting the sp_dboption "test","concat null yields null","false" to work?